home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload Trio 2
/
Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO
/
dir30
/
tabpr212.zip
/
TABPRO.DOC
< prev
next >
Wrap
Text File
|
1993-11-26
|
36KB
|
773 lines
Tab123 Professional, copyright 1991-93 Mountain Software
-=TabPro=-
AutoCAD Spreadsheet Interface
Version 2.1
October 27, 1993
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
Autodesk Registered Application Developer
Novell Professional Developer
Jerry Workman, P.E.
1579 Nottingham Road
Charleston, WV 25314
CIS 70717,3564
Internet 70717.3564@compuserve.com
Orders: 1-800-2424-PsL
Tech Support: 304-346-9585
FAX 304-744-1785
Table of Contents
U s i n g T a b P r o . . . . . . . . . . . . . . . . . . . . 1
Introduction . . . . . . . . . . . . . . . . . . . . . . . . 1
Installation . . . . . . . . . . . . . . . . . . . . . . . . 1
Install Program . . . . . . . . . . . . . . . . . . . . . 1
Manual Install (DOS386 platform) . . . . . . . . . . . . . 1
Manual Install (Microsoft Windows platform) . . . . . . . 2
Running TabPro . . . . . . . . . . . . . . . . . . . . . . . 2
Release 12 Interface: . . . . . . . . . . . . . . . . . . . 2
Filename . . . . . . . . . . . . . . . . . . . . . . . . . 2
Range Button . . . . . . . . . . . . . . . . . . . . . . . 2
Range Edit Box . . . . . . . . . . . . . . . . . . . . . . 2
Text Layer Button and Dropdown . . . . . . . . . . . . . . 3
Text Style Button and Dropdown . . . . . . . . . . . . . . 3
Style Creation Dialogue . . . . . . . . . . . . . . . . . 3
Scaling... . . . . . . . . . . . . . . . . . . . . . . . . 3
Text Height . . . . . . . . . . . . . . . . . . . . . . . 3
Row Scale Factor . . . . . . . . . . . . . . . . . . . . . 4
Column Offset Factor . . . . . . . . . . . . . . . . . . . 4
Grid... . . . . . . . . . . . . . . . . . . . . . . . . . 4
Grid Layer . . . . . . . . . . . . . . . . . . . . . . . . 4
Table... . . . . . . . . . . . . . . . . . . . . . . . . . 4
Update Button... . . . . . . . . . . . . . . . . . . . . . 5
Release 11 Interface . . . . . . . . . . . . . . . . . . . . 5
Draw Menu . . . . . . . . . . . . . . . . . . . . . . . . 5
Parms Menu . . . . . . . . . . . . . . . . . . . . . . . . 6
Commands . . . . . . . . . . . . . . . . . . . . . . . . . . 6
TabPro API . . . . . . . . . . . . . . . . . . . . . . . . . 7
(C:TABPRO <file> <range> <point>) . . . . . . . . . . . . 7
(C:TABPRO_UPDATE <mode>) . . . . . . . . . . . . . . . . . 7
Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Suggestions . . . . . . . . . . . . . . . . . . . . . . . . 8
A d d e n d u m . . . . . . . . . . . . . . . . . . . . . . . . 9
Liability . . . . . . . . . . . . . . . . . . . . . . . . . 9
Author . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Trademark . . . . . . . . . . . . . . . . . . . . . . . . . 9
L i c e n s e . . . . . . . . . . . . . . . . . . . . . . . . 10
Registration Information . . . . . . . . . . . . . . . . . 10
I n d e x . . . . . . . . . . . . . . . . . . . . . . . . . . 13
U s i n g T a b P r o
=========================
Introduction
-------------------------
TabPro imports Lotus 123, Symphony, and Excel spreadsheet files
into an AutoCAD drawing. TabPro runs from within the AutoCAD
drawing editor and will read Lotus WKS thru WK4 files as well as
Excel XLS files directly. The spreadsheet range can be imported
either as a table of text entities or as a block insert with each
cell defined as a block attribute. In addition, TabPro creates a
cell grid to enclose the table.
TabPro provides full control over the size, shape, location,
layer and style of the table. Text styles (fonts) and layers can
be created "on the fly" within TabPro, grid appearance and
linetype as well as border type are also user defined. The
program reads not only the data from the spreadsheet file, but
also calculated formula values, formatting information, column
widths, cell formats, and cell alignment.
Utilizing the AutoCAD Proteus (Windowed) graphic user interface,
TabPro also adds the command DDTYLE, a dialogue box interface for
text style creation. TabPro is a ADS (AutoCAD Development System)
application for AutoCAD 386 release 11 or release 12 and AutoCAD
for Windows. TabPro works on any IBM PC compatible computer
capable of running these versions of AutoCAD.
Installation
-------------------------
Install Program
Place the distribution diskette into a floppy drive, Go to the
DOS prompt, log to the floppy drive and enter "INSTALL".
Example:
C:\ a:
A:\ install
When prompted, enter the source drive (eg A or B), destination
drive (eg C, D, etc) and subdirectory (eg C:\TABPRO). The install
program will create the subdirectory and extract the program
files from the TabPro archive file to that directory.
Manual Install (DOS386 platform)
Create a new subdirectory for the TabPro files. From the DOS
command prompt, enter A:\UNZIP A:\TABPRO*.ZIP /o C:\TABPRO.
TabPro Documentation page 4
=================================================================
Manual Install (Microsoft Windows platform)
A:\UNZIP A:\TABPRW*.ZIP /o C:\TABPRO for the Microsoft Windows
version.
If you wish to install both DOS386 and Windows version, then
install each version into a different subdirectory.
Running TabPro
-------------------------
First load the ADS program:
Command: (XLOAD"C:/TABPRO/TABPRO")
You may also add TABPRO to your ACAD.ADS file to load TabPro
automatically each time that you start AutoCAD. Or you can use
the AutoCAD command ACADAPP to load TabPro.
Then execute...
Command: TabPro
Release 12 Interface:
-------------------------
TabPro Dialogue
The dialogue displays a group of buttons, list boxes, and edit
boxes to collect user data.
Filename
Enter the Filename of a Lotus 123 or Excel file, or select the
File Button to invoke the file dialogue box. TabPro supports
all Lotus 123 file formats as well as all versions of Excel
XLS files.
Range Button
Select the Range button to pick a named range from the
worksheet file. The range button will be grayed out if there
are no range names defined in the worksheet.
Range Edit Box
Enter the range to import into the edit box. The range must be
in the form <sheet>:<column><row> .. <sheet>:<column><row>.
TabPro Documentation page 5
=================================================================
The <sheet> specifier is only necessary if you wish to
extract data from a sheet other that sheet "A" in a Lotus 123
WK3/WK4 file.
Examples:
A1..E25 column A row 1 to column E row 25
B:C11..B:G34 sheet B column A row 1 to column E row 25
* all cells (a blank range also selects all)
MY_RANGE named range
Text Layer Button and Dropdown
This button invokes the AutoCAD "DDLMODES" dialogue box where you can
create a new layer or modify layer settings. If you make a different
layer current while in the DDLMODES dialogue, that layer then becomes
the text layer. You can select the AutoCAD layer on which to place cell
text entities from the dropdown box.
Text Style Button and Dropdown
Use the Styles button to create a new text style. The default text style
is the current AutoCAD style in effect when you first start TabPro.
Select the AutoCAD text style to use for text entities from the dropdown
box.
Style Creation Dialogue
Select a text style to create either from the pick list or the icon menu. You
may page through the styles by selecting the <Next> and <Previous> buttons.
Once a style is selected the style parameters must be specified to completely
define the text style. Any existing text style of the same name will be
overwritten.
> Height: Text height in drawing units
> Width Factor: Width multiplier
> Obliquing Angle: Text slant angle
> Backwards: Mirror text in X plane
> Upside down Mirror text in Y plane
> Vertical Draw vertical text
Scaling...
Select this button to diaplay the scaling dialogue.
Text Height
TabPro Documentation page 6
=================================================================
Enter the text height in drawing units. The default value is taken from
the current style if the style contains a text height, or the AutoCAD
system variable TEXTSIZE. The entire table is scaled based on this
value.
Row Scale Factor
The row scale factor defines the spacing between rows in terms of the
text height. This factor is multiplied by the text height to determine
the row spacing. A value of 1.0 is will allow adjacent text rows to just
touch bottom to top. The default value is 2.00.
Column Offset Factor
The column offset factor defines the horizontal spacing (in characters)
between the start or end of the text and the cell boundary. The default
value is 1.00.
Grid...
Select the grid button to select grid linetype and border line weight. You can
also adjust the density of linetypes using AutoCAD's LTSCALE system variable.
Grid Layer
Select the AutoCAD layer on which to place grid line entities, or select
the Layers button to invoke the AutoCAD "DDLMODES" dialogue box where
you can create a new layer or modify layer settings.
Table...
You may create a table in either of two different forms.
Text and Lines
The table will be created using LINEs for the grid, a POLYLINE for the
border, and TEXT entities in each cell. This format provides for
adjustments of the table layout using the commands STRETCH, MOVE, etc.
Cell contents can be edited using the DDEDIT command.
Block and Attributes
An anonomous block and a block insert entity with attributes is created
in the drawing. Each cell is a visible attribute within the block
insert, and table specifications are saved as invisable attributes. The
cell data and table specs can be edited using the command DDATTE If the
spreadsheet range or any of the other specs are changed, then the new
specs will apply when the table is updated from disk. Any changes to the
cell values will be lost when the table is updated.
TabPro Documentation page 7
=================================================================
Tables created in block mode can be automatically updated from the spreadsheet
when the drawing is opened by adding the C:TABPRO_UPDATE function to the
S::STARTUP function in your ACAD.LSP file. They can also be updated by
clicking the "Update" button.
Update Button...
The table update button updates all block mode tables in the drawing.
Block mode tables are linked to the spreadsheet file and range with
invisible attributes. You can also use the command TABPRO_UPDATE or the
function (C:TABPRO_UPDATE) to update tables.
Release 11 Interface
-------------------------
AutoCAD release 11 does not support the Proteus dialogue box interface. A
command line interface is provided that will be invoked automatically if
release 11 is detected. It can also be call via the command "TABPRO11". Data
is collected through a series of prompts:
Draw/Parms/Exit/<Draw>:
Draw: Draws the table in the drawing. You are prompted for the file name,
range, text size (if the current style has a text size of 0.0) and table
location.
Parms Modify table and style settings...
Exit: Exits TabPro with no action.
Draw Menu
Text Height <0.20>:
Enter the text height for all entities in the table. The default height
for the current test style is used if no value is entered.
Enter worksheet filename[]:
Enter any valid DOS filename including Drive:\path\filename.ext. If no
file extension is specified then ".WK1" is appended.
Enter worksheet range[]:
Enter either a worksheet range in the usual form (eg BA34..CL63) or any
range name defined in the worksheet. Enter an asterisk "*" to specify
the entire worksheet.
Table Insertion point:
TabPro Documentation page 8
=================================================================
Pick a point where for the upper left corner of the table.
The border, grid and table are then drawn. The values entered are saved for
the drawing session so you may enter "U" to undo and easily re-insert that
table if the results are not as expected.
Parms Menu
RowScale/CharOffset/LayerGrid/GridType/BorderType/TableMode/Exit/[Exit]:
RowScaleFactor: Centers / spacing between rows. A value of 2.0 (the default)
will space rows at 2.0 times text height (determined by the AutoCAD text style
active, or the height entered by the user).
CharOffsetFactor: Offset of the first and last character(s) from the left and
right margins. A value of 1.0 (the default) will make cell margins 1.0 X text
character width (determined by the AutoCAD text style active).
LayerGrid: Layer where the grid and border will be drawn. (Default GRID) If
the layer does not exist, it will be created.
GridType: Enter an integer between 0 and 3 to select the linetype of grid to
be drawn:
0 - No grid
1 - Dotted line (DOT2 linetype)
2 - Dashed line (DASHED2 linetype)
3 - solid line (CONTINUOUS linetype)
BorderType: Enter an integer between 0 and 3 to select the type of border to
be drawn around the table:
0 - No Border
1 - Thin Border
2 - Medium Border
3 - Thick Border
TableMode: Enter 0 to create the table with LINE and TEXT entities; or 1 to
create the table as a block INSERT with table settings as well as cell data as
attributes.
Commands
-------------------------
Commands defined by TabPro
TABPRO Displays the TabPro Dialogue
TABPRO11 Runs TabPro in command line mode.
TABPRO_UPDATE Conditionally updates block mode tables
TABPRO_PASSWORD Register TabPro with your name and password.
TabPro Documentation page 9
=================================================================
TabPro API
-------------------------
The TabPro Applications Program Interface creates two functions for use by
AutoLISP and ADS programmers.
(C:TABPRO <file> <range> <point>)
Use: a dual use function that either creates a table from a spreadsheet file
and range, or returns the spreadsheet data as an AutoLISP list.
Parameters:
file <str> the worksheet filename (eg C:\EXCEL\TABLE.XLS)
range <str> the named range or range specification (eg A1..D10)
point <point> the insertion point for the upper left corner if the table
if the point paramter is not present the data will be
returned in the form of an AutoLISP list in row / column
order of dotted pairs. Each dotted pair will contain the
cell address and formatted cell contents.
Return value example:
(("A1" . "Planes") ("B2" . "Boats") ("A2" . "123") ("B2" . "23"))
(C:TABPRO_UPDATE <mode>)
Use: Updates table links to external spradsheet files using the file, range,
and other parameters contained in the block's attributes. This function is
used to automatically update tables when a drawing is loaded. You can place
the function in the file ACAD.LSP file within the S::STARTUP function
to execute after a drawing loads. ACAD.LSP might contain the following:
(xload "TABPRO") ; load TabPro
(defun S::STARTUP()
(C:TABPRO_UPDATE)
)
Parameters:
mode <int> 0 or nil conditional update, if the spreadsheet file has
changed then the table will be updated.
1 update all tables unconditionally
Limits
-------------------------
TabPro can not read SQZ files or Excel workbooks. If you use a different
spreadsheet program (eg Quattro) then save your file as a WK? or XLS file,
most spreadsheets (and many other programs) provide can save in these file
formats.
TabPro Documentation page 10
=================================================================
TabPro can not recalculate your spreadsheet. If you use manual recalculation
then be sure to recalculate prior to saving so that formula values will be
correctly displayed.
If you insert the entire worksheet, the grid may be larger than expected.
TabPro extracts the worksheet dimensions from the Lotus or Excel file before
reading the data, and can include blank formatted cells.
Suggestions
-------------------------
While developing your table in Lotus 123 or Excel make sure that text does not
overlap into the next cell. Set column widths to a value that is just wider
than the values and text. Use "Comma" or "Dollars" formats to make large
values easier to read.
You can use other data sources (eg dBase / Paradox / Quattro, etc) by saving
in one of the TabPro supported file formats. Most database managers and other
applications can save to a Lotus or Excel file format.
Use Lotus/Excel names to define area ranges for the cell ranges that you wish
to later import into AutoCAD.
You can use TabPro to transfer attribute information from Generic CADD to
AutoCAD. In CADD 5.0, export attribute data as a WK1 format file; then use
TabPro to read the file into AutoCAD as a text table.
A d d e n d u m
=========================
Liability
-------------------------
Careful testing has been made to ensure that these programs perform correctly.
No liabilities are assumed in the use or misuse of this program resulting in
data loss or damage. It is the users responsibility to be sure that the
results are as expected.
Author
-------------------------
Jerry Workman, PE
Mountain Software
1579 Nottingham Rd.
Charleston, WV 25314
Phone: 304-744-7748 / 304-346-9585
FAX: 304-744-1785
Compuserve: 70717,3564
Internet: 70717.3564@compuserve.com
Copyright 1991,92,93 by Mountain Software All rights reserved
Trademark
-------------------------
Mountain Software, Read_WKS, Tab123, and TabPro are trademarks of Mountain
Software. MS-DOS and Excel are registered trademarks of Microsoft Corporation.
PC-DOS is a registered trademark of IBM Corporation. AutoCAD is a registered
trademark of AutoDesk. 123 and Symphony are registered trademarks of Lotus
Development Corporation
L i c e n s e
=========================
Shareware
This version of TabPro is NOT public domain or free software, but is being
distributed as "shareware". You may try it out to see if it is useful for you.
If you wish to continue to use TabPro you must register. Registered users are
provided with a password to remove the opening delay and with support for one
year.
The program in the form of the original archived file only may be freely
distributed, but not sold (except under license, or for a nominal copying or
disk fee).
Non-registered users of this software are granted a limited 30 day license to
make an evaluation copy for trial use for the purpose of determining whether
TabPro is suitable for their needs. At the end of this trial period, you may
either register your copy, or discontinue using TabPro.
All users are granted a limited license to copy TabPro only for the trial use
of others and subject to the above limitations. This license does NOT include
distribution or copying of this software for use:
1. In connection with any other product or service.
2. For general use within a company or institution.
3. For distribution in modified form; i.e., the file containing this
license information MUST be included, along with the full TabPro
documentation.
Operators of electronic bulletin board systems (Sysops) are encouraged to post
TabProxx.ZIP for downloading by their users, as long as these conditions are
met.
Registration Information
-------------------------
A TabPro registration licenses you to use the product on a regular basis.
Individual license cost for TabPro is $50 including a diskette with the latest
version of TabPro and the printed manual. Registration also entitles you to
telephone support and notification of updates and new products. Print file
ORDER.DOC and mail or FAX the form to the address above. You can also place an
order by telephone or through Compuserve (GO SWREG).
Educational institutions, full-time students and BBS sysops can apply a 50%
discount. PLEASE include your educational institution letterhead (with your
title), or a photocopy of your most recent registration slip, or the name and
number of your BBS.
TabPro Documentation page 13
=================================================================
Definition of Shareware
Shareware distribution gives users a chance to try software before buying it.
If you try a Shareware program and continue using it, you are expected to
register. Individual programs differ on details -- some request registration
while others require it, some specify a maximum trial period. With
registration, you get anything from the simple right to continue using the
software to an updated program with printed manual.
Copyright laws apply to both Shareware and commercial software, and the
copyright holder retains all rights, with a few specific exceptions as stated
below. Shareware authors are accomplished programmers, just like commercial
authors, and the programs are of comparable quality. (In both cases, there are
good programs and bad ones!) The main difference is in the method of
distribution. The author specifically grants the right to copy and distribute
the software, either to all and sundry or to a specific group. For example,
some authors require written permission before a commercial disk vendor may
copy their Shareware.
Shareware is a distribution method, not a type of software. You should find
software that suits your needs and pocketbook, whether it's commercial or
Shareware. The Shareware system makes fitting your needs easier, because you
can try before you buy. And because the overhead is low, prices are low also.
Shareware has the ultimate money-back guarantee -- if you don't use the
product, you don't pay for it.
Disclaimer - Agreement
Users of TabPro must accept this disclaimer of warranty: "TabPro is supplied
as is. The author disclaims all warranties, expressed or implied, including,
without limitation, the warranties of merchantability and of fitness for any
purpose. The author assumes no liability for damages, direct or consequential,
which may result from the use of TabPro."
TabPro is a "shareware program" and is provided at no charge to the user for
evaluation. Feel free to share it with your friends, but please do not give
it away altered or as part of another system. The essence of "user-supported"
software is to provide personal computer users with quality software without
high prices, and yet to provide incentive for programmers to continue to
develop new products. If you find this program useful and find that you are
using TabPro and continue to use TabPro after a reasonable trial period, you
must make a registration payment of $50 to Mountain Software. The $50
registration fee will license one copy for use on any one computer at any one
time. You must treat this software just like a book. An example is that this
software may be used by any number of people and may be freely moved from one
computer location to another, so long as there is no possibility of it being
used at one location while it's being used at another. Just as a book cannot
be read by two different persons at the same time.
Commercial users of TabPro must register and pay for their copies of TabPro
within 30 days of first use or their license is withdrawn. Site-License
arrangements may be made by contacting Mountain Software.
Anyone distributing TabPro for any kind of remuneration must first contact
Mountain Software at the address below for authorization. This authorization
TabPro Documentation page 14
=================================================================
will be automatically granted to distributors recognized by the (ASP) as
adhering to its guidelines for shareware distributors, and such distributors
may begin offering TabPro immediately (However Mountain Software must still be
advised so that the distributor can be kept up-to-date with the latest version
of TabPro.).
You are encouraged to pass a copy of TabPro along to your friends for
evaluation. Please encourage them to register their copy if they find that
they can use it.
Jerry Workman a member of the Association of Shareware Professionals (ASP).
ASP wants to make sure that the shareware principle works for you. If you are
unable to resolve a shareware-related problem with an ASP member by contacting
the member directly, ASP may be able to help. The ASP Ombudsman can help you
resolve a dispute or problem with an ASP member, but does not provide
technical support for members' products. Please write to the ASP Ombudsman at
545 Grover Road, Muskegon MI 49442, or send a message via Compuserve mail to
ASP Ombudsman 70007,3536
I n d e x
=========================
123 . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3, 7-9
ACAD.ADS . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
ACAD.LSP . . . . . . . . . . . . . . . . . . . . . . . . . . 5, 7
ADS . . . . . . . . . . . . . . . . . . . . . . . . . . . 1, 2, 7
API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
ASP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
attributes . . . . . . . . . . . . . . . . . . . . . . . . . 4-7
AutoCAD . . . . . . . . . . . . . . . . . . . . . . . . 1-6, 8, 9
block . . . . . . . . . . . . . . . . . . . . . . . . . . . 1, 4-6
border . . . . . . . . . . . . . . . . . . . . . . . . . 1, 4, 6
Command . . . . . . . . . . . . . . . . . . . . . . . . 1, 2, 4-6
Compuserve . . . . . . . . . . . . . . . . . . . . . 1, 9, 10, 12
dialogue . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6
directory . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
disk . . . . . . . . . . . . . . . . . . . . . . . . . 4, 10, 11
DOS . . . . . . . . . . . . . . . . . . . . . . . . . . . 1, 5, 9
drawing editor . . . . . . . . . . . . . . . . . . . . . . . . 1
edit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Excel . . . . . . . . . . . . . . . . . . . . . . . . . 1, 2, 7-9
file . . . . . . . . . . . . . . . . . . . . . . 1-3, 5, 7, 8, 10
filename . . . . . . . . . . . . . . . . . . . . . . . . 2, 5, 7
function . . . . . . . . . . . . . . . . . . . . . . . . . . 5, 7
grid . . . . . . . . . . . . . . . . . . . . . . . . . 1, 4, 6, 8
install . . . . . . . . . . . . . . . . . . . . . . . . . . . 1, 2
layer . . . . . . . . . . . . . . . . . . . . . . . . . 1, 3, 4, 6
license . . . . . . . . . . . . . . . . . . . . . . . . . . 10, 11
linetype . . . . . . . . . . . . . . . . . . . . . . . . 1, 4, 6
Lotus . . . . . . . . . . . . . . . . . . . . . . . . . 1-3, 8, 9
range . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-5, 7
scale . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
shareware . . . . . . . . . . . . . . . . . . . . . . . . 1, 10-12
SQZ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
style . . . . . . . . . . . . . . . . . . . . . . . . . . . 1, 3-6
subdirectory . . . . . . . . . . . . . . . . . . . . . . . . 1, 2
table . . . . . . . . . . . . . . . . . . . . . . . . . 2, 1, 4-8
text . . . . . . . . . . . . . . . . . . . . . . . . . 1, 3-6, 8
Undo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
update . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-7
worksheet . . . . . . . . . . . . . . . . . . . . . . . 2, 5, 7, 8
XLOAD . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2, 7
ZIP . . . . . . . . . . . . . . . . . . . . . . . . . . . 1, 2, 10